F4 - Spreadsheets

Spreadsheets are most useful for working with

• videos

• payroll

• networks

• brochures

A spreadsheet is a grid of

• cells

• rows

• columns

• addresses

The purpose of the VLOOKUP function is to _________ related records.

• delete

• find

• replace

• summarise

Spreadsheets allow you to perform _________ calculations.

• how to

• what if

• when is

• why not

Which of the following is not a purpose of a spreadsheet?

• to create simple tabulations such as invoices

• to hold accounting or financial data

• to perform advanced text processing

• to capture, manipulate and display numeric data

B5:D9 is best described as a

• cell range

• row range

• column range

• cell reference

Which of the following chart types is best for displaying the contribution for each part of the total?

• bar chart

• column chart

• line graph

• pie chart

The text 'Total Amount' in a cell is best described as a _________.

• value

• formula

• label

• function

By default, numeric entries into the spreadsheet are aligned __________.

• left

• right

• centre

• justified

If cell address contains $B$7, it is what type of a cell reference?

• mixed

• relative

• absolute

• combined