Font size
WorksheetsInfo Tech Excel Quiz
Total questions: 20
Worksheet time: 11mins
In Excel, which of the following is NOT a function?
Sum
Average
Add
Maximum
What are rows and columns?
Rows run from left to right and are designated by a number while columns run from top to bottom and are designated by a letter.
Rows run from left to right and are designated by a letter while columns run from top to bottom and are designated by a number.
Rows run from top to bottom and are designated by a number while columns run from left to right and are designated by a letter.
Rows run from top to bottom and are designated by a letter while columns run from left to right and are designated by a number.
Data on which you can perform calculations on is called? Select the BEST possible answer.
Labels
Cells
Values
Formulae
The cell reference for the sixth row and fourth column is: Select the BEST possible answer.
F4
D6
F6
D4
What are values and labels?
A value is any data that can be used in calculation while a label is a text entry and is used as an identifier.
A label is any data that can be used in calculation while a value is a text entry and is used as an identifier.
A value and a label can be used in calculation and can also be used as an identifier.
A value and a label can be used in calculation but cannot be used as an identifier.
Which of the following is NOT a type of chart in Microsoft Excel?
Grouping Chart
Bar Chart
Line Chart
Pie Chart
Select True or False. A Formula is an instruction that tells the computer to work out the answer for the values entered. When writing a formula putting the equal sign at the beginning is not necessary.
False
True
Which of the following is NOT a form of cell referencing?
Direct referencing
Relative referencing
Absolute referencing
Mixed referencing
What are the viewing options in Microsoft Excel?
Page Layout view
Normal view
Print view
Page Break view
Select True or False. Spreadsheet software is used to perform calculations and keep track of tabular data.
True
False
Spreadsheets are made up of worksheets, what is a worksheet? Select the BEST possible answer.
Worksheets consists of space for drawing graphics.
Worksheets are blank documents for typing letters.
Worksheets consists of columns and rows, the columns are lettered and the rows are numbered.
Worksheets contain only pictures.
What are spreadsheets mostly used for?
Spreadsheets are used to create presentations using animations.
Spreadsheets are used to perform calculations and keep track of tabular data.
Spreadsheets are used to create documents and letters.
Spreadsheets are used to maintain the computer by stopping viruses.
What is the most efficient way of repeating a formula in multiple rows?
Copying and pasting the formula in each cell.
Dragging the Fill Handle downwards.
Rewriting the formula in each cell.
Cutting and pasting the formula in each cell.
Harry is preparing a worksheet and would like to move down one cell, what key strokes will he have to press? Select ALL possible answers.
Down arrow key
Enter key
Up arrow key
Tab
The formula for calculating the Total Students in all 4 classes for IT is:
B2+B3+B4+B5
B2+C2+D2+E2
=B2+C2+D2+E2
=B2+B3+B4+B5
John is trying to build a computer. He acquired a list of parts and their current prices from AMAZON. He decided create a spreadsheet to track this data as seen in the picture. What are all the ways that he can calculate the TOTAL cost of the computer?
=B2+C2+D2+E2+F2+G2
=SUM(B2:G2)
=H2
=B2+C3+D4+E5+F6+G7
Having calculated the TOTAL sum of the computer parts, he wanted to know what was the cost in TT dollars of the items. John found that the current exchange rate was $6.88 TT was worth $1 US dollar. Which of the following ways can John calculate the TOTAL cost in TT dollars for the items?
=B3+C3+D3+E3+F3+G3+H3
=PRODUCT(B3,H2)
=H3*B3
=H2*B3
What is the difference between a workbook and a worksheet? Select 2 correct answers.
A worksheet is the individual parts of a workbook.
A worksheet is the file created in Excel.
A workbook is the individual parts of a worksheet.
A workbook is the file created in Excel.
Jessie is going to prepare her monthly budget in Excel and would like to start it on a new workbook. What instructions would you give Jessie to open a new workbook? Select the BEST possible answer.
Click on the Home menu option and select paste.
Click on the File menu option and click on New and then select Blank workbook.
Click on the File menu option and select open.
Click on the insert menu option and select table.
Select the BEST possible answer. When a formula is copied from one cell to another and the formula remains the same but the cell addresses in the formula change in relation to the position of the new cell this is called:
Relational addressing
Absolute addressing
Relative cell addressing
Mixed addressing
