Exam 1 Flashcards
Control-n
Starts a new blank workbook
Control-b
Uses bold text
Control-I
Uses italic text
How to get a number as a square
Format cells > font > check superscript box
Path to create a custom list
File> options > advanced> edit custom lists
Tool to identify a variance while keeping track of data already verified
Conditional formatting
Most commonly used function in excel
SUM
Excel does not allow _________ in numeric format
Leading zeros
What do cells with comments look like?
Small red triangle in upper right hand corner
Control-;
Shortcut to show current date
Control-:
Shortcut to show current time
How to duplicate a file
View> new window
What group of characters does excel not know?
The alphabet
What is the wildcard symbol for filters?
Asterisk *
Question mark
Control-End
Takes you to the last value in the data
COUNT function
Counts cells with numbers
COUNTA function
Counts every cell that is not empty
Control-A
Opens function arguments dialog box
You cannot use logical functions nested inside _____ or _______
SUMIF, COUNTIF
INT function
Rounds a figure down to nearest whole number
RAND function
Gives a random value between 0 and 1
LEN function
Counts number of characters in text
FIND function
Returns position of specified text
EXACT function
Returns True if two specified cells are the same or else False
CHAR function
Returns character from the number specified
CODE function
Returns the number from the character specified
TEXT function
Changes a number into a text
VALUE function
Changes text into a value
How to clear filters and add back filtering option
Data> click filter button twice (in the sort and filter area)
How to create a copy of a sheet
Right click tab, move or copy, check create a copy box
How to set up filters by within rows or columns
Data> Advanced (sort and filter area)
How to hide formulas so that they cannot be seen but are still used
Right click column, hide
Home>cells>format>hide and unhide
How to lock cells/hide formulas
Right click>format cells> protection> check locked or hidden
How to protect or block altering or selecting cells
Review>protect sheet>enter password and select protection options
How to add a password to a file
File>save as> protect workbook> encrypt with password
How to get to insert function/ the function palette
Home>editing tab> auto-sum drop down> more functions
