Font size
WorksheetsRecap Spreadsheet EP1
Total questions: 22
Worksheet time: 12mins
What is a spreadsheet?
A document filled with row and column in which you can safely store data
A special type of word document that is used to calculate and print values
A specific document used to store, modify, update and calculate a data.
A table consisting of cells that hold accounting or financial data and simulates the tradition spreadsheet
Which of the following is not a formatting type in spreadsheet?
Accounting
Font
Currency
Date and time
Percentage
I am used to tell the location of a specifc cell in a spreadsheet. What am I?
Cell Name
Cell range
Cell location
Cell address
i have a name, an equal sign and also I use cell ranges. What am I?
Functions
Cell ranges
Cell function
Cell places
Select all functions from the lost below.
SELECT ALL THAT APPLY
SUM
IF
PRODUCT
MATHS
DATE
The max function is used to ...
The VLOOKUP Function is used for
Finding a value and using any values that is from that row (running horizontal)
horizontally finding a value and using an vertical value that matches that column
Used to sums all values listed
None of the above
If you are wishing to insert a row or column. it is important to bear that rows are added to the ___________ of the spreadsheet.
Left
Right
No specific direction
_____________________ is used to anchor a cell address that will be used as a range or that should be continuously used.
Relative Addressing
Absolute Addressing
Anchoring Range
None of the above
If a function/formula is copied without ____________, this will produce zero or incorrect values. This type of addressing is known as _______________
Relative cell addressing , absolute cell addressing
Absolute cell addressing , relative cell addressing
Cell ranges, relative cell addressing
None of the above
This is the process of arranging data in a specific order. This can be done in ascending or descending.
Filter
Chart
Sort
Advance Filter
This is used to typically used to help you visualize your results or data.
Bar graph
Pie Chart
Column graph
Line Graph
All of the above
Pivot tables are usually in one or two forms. These are _______________________________
This is the process of selecting specific records that meets a given criteria is known as
Sorting
Filtering
Editing
None of the above
In what tab would you find the option to insert a chart in a spreadsheet?
Home
Review
Charts
Insert
In a class of 26 students, the teacher would like to calculate the average of the class. Which function is the best one to use to complete this task?
MIN
AVERAGE
TOTAL
MAX
In order to link two spreadsheet, you will first need to _____________, then click on the cell in the worksheet and _________.
Type the file name , select done.
Type the equal sign , select start link
Type the file name , select eneter
Type the equal sign , select enter
To make life easier when linking two worksheet, it is best to:
Store both documents the same place
Have both documents open
Delete both documents
None of the above
In order to create pivot table. Microsoft Excel summarize the data by:
Adding everything
Counting everything
Adding or counting everything
Reading, analyzing and producing a excel document summary
this is used to see how many times a item or value appears in a spreadsheet
Cell simular
cell likeliness
Cell means
any of the above
None of the above
________________________ is used to use to count the number of times a value in a set of data.
Value Counter
Cell Value Finder
Frequency Distribution
Place Counter
In order to create a graph in spreadsheet, data MUST be adjacent to each other ?
True
False
