WorksheetsExcel Masterclass
Total questions: 22
Worksheet time: 4mins
This section of Excel allows me to do which commands? (More than 1 answer)
Create a new function
Open an existing Excel file
View my Excel setup
Create a new workbook
What is the Excel function to sum up all values of a specific column, without criteria
SUM
SUMIF
Add
Total
In order to get the average score of the students scores, which Excel function would be best to use.
SUMIF
IF
Flashfill
Average
Clicking here (where the cursor is shown as a cross) will....
Select the specific cell
Select the entire row
Select the entire worksheet
Select the entire column
What will be the result of this function?
10
23
5
56
Which function is correct to count the number of variety of fruits? (more than one correct answer)
COUNT(K21:K25)
COUNTA(K21:K25)
COUNTIF(K21:K25)
COUNT(L21:L25)
Which IF statement is correct?
=IF(C12>70,"Good","Average")
=IF(C12>=70,"Good","Average")
=IF(C12<70,"Good","Average")
=IF(C12<=70,"Good","Average")
Which formula is correct (in order to be able to copy the formula to all blank cells)?
=(B1*A2)
=($B$1*$A$2)
=($B1*A$2)
=(B$1*$A2)
What is the function of the mouse pointer in the image?
It selects the entire column
It selects the entire row
It moves the entire column
it moves the entire row
What is the name of the cell in the worksheet that is currently selected.
Active cell
Highlighted cell
Formula cell
Inactive cell
On which tab would you find margins and page orientation?
Home
Insert
Page Layout
Data
What is the function of the mouse pointer in the image?
It allows you to move the contents of the cell
It allows you to select more than one cell
It copies what is in the cell
It allows you to widen the column
A row is identified by which of the following?
Number
Letter
Symbol
None of the above
The Merge and Center icon will combine the contents of the selected cells into one larger cell.
True
False
Which feature automatically fills in values?
Paste
Wrap Text
Merge and Center
AutoFill
Which of the following is not a correct cell address?
2D
A27
BB15
All of the above
A column is identified by which of the following?
Number
Letter
Symbol
None of the above
Which of the following keys can be used to move around in a worksheet?
Arrow keys
Tab key
Enter key
All of the above
Identify the correct syntax for
VLOOKUP
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, col_index_num, lookup_value,[range_lookup])
=VLOOKUP(lookup_value, table_array, [range_lookup], col_index_num)
Identify the correct syntax for
IF
=IF(logical_test, [value_if_true], [value_if_false])
=IF(logical_test, value_if_true, value_if_false)
=IF(logical_test, [value_if_false], [value_if_true])
=IF([value_if_true], [value_if_false], logical_test)
What does the green triangle represent?
A formula is in this cell.
Cell contains conditional formatting.
A potential error is in the cell.
Marked for Review.
What type of function is used to add the total hours for full-time employees?
SUM
SUMIF
COUNTIF
TOTALSUM
