___________ are used to keep an area of a worksheet visible while you scroll to another area of the worksheet?, Lock Panes, Solid Panes, Stop Panes, Freeze Panes, Freeze Panes can used on both rows and columns?, True, False, Comments can NOT be added to a spreadsheet workbook?, True, False, _____________ cell referencing means that as a formula is copied and pasted somewhere else in your spreadsheet , the cell reference in the formula is changed to reflect the new location?, Relative, Absolute, _____________ cell referencing means a formula is copied and pasted somewhere else in your spreadsheet, the cell reference in the formula do not change?, Relative, Absolute, Which sign is used to indicate an absolute cell reference?, %, =, $, £, A ____________________ is a pre-defined formula?, Cell, Sort, Function, Worksheet, What function counts a value depending on a certain condition?, Countif, Count, AutoSum, Average, What function search for a value in the first column of a specified table, and returns a value from the specified adjacent column?, VLookup, Countif, Average, Sort, _________________ is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria?, Additional formatting, Conditional formatting, Standard formatting, Auto formatting.

Intermediate Excel Quiz

bởi
In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

)
Bạn có muốn khôi phục tự động lưu: không?