SPREADSHEET MODELLING FINAL EXAM
LATEST 2024 ACTUAL EXAM
when you click a chart, you will see two additional tabs (_ and ) for working with the chart
a. layout tab and formula tab
b. view tab and design tab
c. design tab and format tab
d. formulas tab and format tab – ANSWER- c. design tab and
format tab
tiny charts embedded in a cell that display a visual trend
summary alongside your data are called _.
a. data markers
b. data labels
c. sparklines
d. data series – ANSWER- c. sparklines
T/F: the formula bar displays the value or formula in the active
cell. – ANSWER- true
the _ function counts the number of cells within a range that meet the criteria entered. a. sum b. if c. countif d. median – ANSWER- c. countif T/F: when a new column is inserted into a worksheet, the remaining columns move to the right. – ANSWER- true the countif function has two arguments _.
a. a value as the criteria and an average of a range of cells
b. the range of cells to sum and the criteria
c. the range of cells to check and the criteria
d. the range of cells to check and the sum of the range –
ANSWER- c. the range of cells to check and the criteria
where do sheet tabs display in a workbook?
a. under the ribbon
b. lower area of the workbook window
c. on the status bar
d. on the right side of the workbook window – ANSWER- b.
lower area of the workbook window
the median function finds . a. the average value in a range of cells b. the one number that corresponds to an argument in the function c. all numbers that correspond to an argument in the function d. the middle value in a range of cells – ANSWER- d. the middle value in a range of cells which of the following excel features recognizes a pattern in the data of a worksheet? a. if function b. countif function c. find and replace d. flash fill – ANSWER- d. flash fill in a conditional format, we use to represent the value of a
cell relative to other cells
a. excel table
b. data bar
c. filter
d. sparkline – ANSWER- b. data bar
we can group multiple worksheets by right-clicking on the sheet
tab, and then click _ on the shortcut menu. a. tab color b. select all sheets c. grouping d. protect sheet – ANSWER- b. select all sheets T/F: you can sort a table in ascending or descending order. – ANSWER- true what are the default names of worksheets? a. sheet1, sheet2, etc. b. worksheet1, worksheet2, etc. c. 1, 2, 3, etc. d. excel 1, excel 2, etc – ANSWER- a. sheet1, sheet2, etc. if you edit data in a worksheet that is associated with a pie chart, _.
a. the pie slices will be automatically updated
Download the full exam pdf here https://learnexams.com/search/study?query=