stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
WEBAPPS SPREADSHEET QUIZ Flashcards | StudBud
Explore
/
WEBAPPS SPREADSHEET QUIZ
WEBAPPS SPREADSHEET QUIZ
18 terms
·
StudBud Administration
·
24 plays
Imported from external platform
Flashcards
18 cards
F
Practice quiz
P
Host live
L
Questions
18
Answers
1
Identify the feature that has been applied to row 1
Freeze
Right align
Cell protection
Text Wrap
2
If cell F1 has the formula =C3&D3
EmilySmith
emily smith
error message
Emily Smith
3
When a cell changes colour automatically upon certain data being input is an example of what?
Formula based formatting
Conditional Formatting
Automatic Formatting
Dependant Formatting
4
When the contents of a cell displayed as ######## - What does this mean?
The cell contains a hyperlink
The cell is too narrow
The alignment of the cell contents is incorrect
The Formula in the cell contains an error
5
When data validation is used for manual input how can the user be helped after entering the data item into a cell?
Use an error message
Use an input message
Check the data is valid
Use an output message
6
What would applying this formula to the spreadsheet produce: =MID(B1,5,2)&MID(B1,8,1)&MID(1A,14,1)&RIGHT(B1,5)
read alone
e oya
eoya
readalone
7
The criteria "equals", "contains", "does not contain" can be applied to which of the following:
Date
Formula
Text
Numbers
8
A cell in a spreadsheet changes flil colour depending on the data that is entered. What is the term of this feature?
Conditional Formatting
Restricted Formatting
Dependant Formatting
Complex Formatting
9
What one of the following would the function CONCATENATE be used for?
Total any numerical values in a row or column
Append string to one another
Total the values of identified cells
Split a string into sub-strings
10
Data validation is used to ensure that only a number between 0 and 100 can be entered.
Range Check
Error Checking
Data Check
Restricted List
11
Which one of the following could be used to validate input?
Column Letter
Row Number
String Type
Text Length
12
Identify the feature that has been applied to the spreadsheet below:
Freeze Row
Conditional Formatting
Hide Columns
Sort Columns
13
Which one of the following describes what a Marco is:
Creating a pre-defined style
A set of recorded operations
Examining isolated areas of a spreadsheet
A mathematical function
14
A set of operations has been recorded and can be activated at a single keystroke. What is this feature known as?
A complex function
A pre-defined function
A template
A macro
15
What is a circular reference in a spreadsheet a type of?
A pre-defined formatting style
A formula which includes a loop.
A formula with relative cell referencing
Error in a formula
16
What type of formatting has been applied to the columns??
Left Align
Justification
Right Align
Text Wrap
17
A range of cells maybe referred to by name if they have been which one of the following:
LINKED
GROUPED
SELECTED
IDENTIFIED BY THEIR ROW AND COLUMN REFERENCES
18
Which one is true?
Workbooks cannot contain formula
Worksheets cannot reference another worksheet
A workbook can contain several worksheets
A worksheet can contain several workbooks
