Microsoft excel computer skills practice test with complete verified solutions 2024

Grid lines Light gray lines that divide each of the cells,rows, and columns on the spreadsheet. Merge To combine into one Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:15 Full screen Concatenate To combine a string of text, usually use when combining a last name and first name into separate cells into one full name in one cell. Auto fill A tool which fills in a field or cells automatically. Column The vertical, up/down parts of a spreadsheet denoted by capital letters. Row The horizontal side to side parts of a spreadsheet denoted by numbers. Cell location Referring to a rectangle on a spreadsheet by naming the column and then the row which it lies, like in a game of battleship. Example cell A,1 Cell The rectangle or field you can type in on a spreadsheet for and when A column it intersects with a row. Workbook The entire excel spreadsheet file you're working in, it can contain one or more worksheets. Think of it as a book made up of many sheets of paper. Worksheet A part/page on an Excel spreadsheet file you're working in, think how many sheets make up a book Autosum Automatically adds up values in a row or column Sort To put in order Filter To remove unwanted pieces of data from view in a table Portrait orientation Vertical, up/down positioning of a sheet Landscape Horizontal, side to side positioning of a sheet