ISM 3011 EXCEL EXAM 1 QUESTIONS AND ANSWERS
The cell reference for a range of cells that starts in cell B1 and goes over to column G
and down to row 10 is _____. - Answers - B1:G10
In the Excel address C5 the C refers to - Answers - the column of the cell
A named range in Excel - Answers - can be referenced by its name from all worksheets
Which of the following is an absolute cell reference? - Answers - $B$3
If a function is included in an argument within a function, it is called a __________ -
Answers - nested function.
Picture of an Excel Spreadsheet with 5 in cell A1, 4 in cell b1, 6 in cell a2, 7 in cell b2, 2
in cell c1 and 8 in cell c2.
If the following IF function, =IF(A2<B2,A3,B3), were place in cell B4 what would be
displayed? - Answers - 2
To include a character value in an IF function - Answers - the character must be in
double quotes
The following value "###########" in a cell of an Excel spreadsheet indicates -
Answers - a number and format combination that is too large for the cell
The count function increments by 1 for - Answers - each cell in the range that contains a
numeric value
A pie chart can contain _____ data ranges. - Answers - 1
The formula =(4 + 3) * 2 will evaluate as: - Answers - 14
After performing an arithmetic action on two cells containing dates and the result is a
number, you should - Answers - format the cell to show a date
The mode function will give you the - Answers - the most common occurring value of a
range of values
If you wish to keep the titles in column A visible as you page to the right you should -
Answers - you should freeze the first column
To calculate the Mean of a set of numbers you would use the ________ function. -
Answers - Average
The cell reference for a range of cells that starts in cell B1 and goes over to column G
and down to row 10 is _____. - Answers - B1:G10
In the Excel address C5 the C refers to - Answers - the column of the cell
A named range in Excel - Answers - can be referenced by its name from all worksheets
Which of the following is an absolute cell reference? - Answers - $B$3
If a function is included in an argument within a function, it is called a __________ -
Answers - nested function.
Picture of an Excel Spreadsheet with 5 in cell A1, 4 in cell b1, 6 in cell a2, 7 in cell b2, 2
in cell c1 and 8 in cell c2.
If the following IF function, =IF(A2<B2,A3,B3), were place in cell B4 what would be
displayed? - Answers - 2
To include a character value in an IF function - Answers - the character must be in
double quotes
The following value "###########" in a cell of an Excel spreadsheet indicates -
Answers - a number and format combination that is too large for the cell
The count function increments by 1 for - Answers - each cell in the range that contains a
numeric value
A pie chart can contain _____ data ranges. - Answers - 1
The formula =(4 + 3) * 2 will evaluate as: - Answers - 14
After performing an arithmetic action on two cells containing dates and the result is a
number, you should - Answers - format the cell to show a date
The mode function will give you the - Answers - the most common occurring value of a
range of values
If you wish to keep the titles in column A visible as you page to the right you should -
Answers - you should freeze the first column
To calculate the Mean of a set of numbers you would use the ________ function. -
Answers - Average
