Answer:
Use the HLOOKUP function in the cell E2 by specifying the student's hourly rate value, the range of cells of the table holding the information, the row from which to return the value, and a value of true or false for approximate or exact match respectively.
Explanation:
Microsoft Excel is a statistics tool used for data analysis. It has several functions and graphical properties for cleaning and representing data.
The HLOOKUP function is an example of a search function in excel, it returns a value based on another value from a range of cells. The function accepts four arguments, they are, the value to be searched, the range table or cell range to search, the row to get the search value, and a mode of return value to return, could be either true for an approximate match or false for an exact match.
Umm
This is to bunch of questions..
Answer:
Input devices: For raw data input.
Processing devices: To process raw data instructions into information.
Output devices: To disseminate data and information.
Storage devices: For data and information retention.
Answer:
See explanation below.
Explanation:
File organization is very important especially when one is working with numerous files from different applications.
When you are working with spreadsheets, word processing documents, presentation slides, images and sound files, it is important to create folders and sub-folders to make locating your files a lot easier.
- Make sure you have all your files saved with names that are relevant to your school project.
- Create a sub-folder to store all spreadsheets files, create a sub-folder to store all word processing files, create a sub-folder to store all presentation slides and create another folder to store images and sound files. You do this to make it easy for you to locate whichever file you want.
- You create the sub-folder by right clicking on your documents section and clicking on new folder. Type in the name of the folder and save.
- After creating sub-folders, create a general folder for all your folders by using the same method in step 3. Copy all your sub-folders into this major folder. You can name this folder the name of your school project.
This way, you never have to look for any files for your school project.
