CGS 1070 OPT OUT EXAM / EXCEL GRADER SKILLS
download and save
select file > save as > download a copy
workbook locate and launch
file > open > Press Cltr + 0 to quickly open Backstage view
excel insert new column
right click whole column to the right where you want to add column width ( column
height) type column width & select OK
add data to cells
on worksheet click a cell? enter your number needed > Enter tab
Bold text
click bold Ctrl+B
change font size
file > options > dialog box click general
increase width of columns
select a column or range of column > home tab > format column width & select OK
center and Italicize text
select text format > click bold Italic Underline button Home tab > Press Cltra + I
Use the sum function
select cell to the # you want to sum, click AutoSum on Home tab > Enter
use the fill handle
select cells ? small square bottom right corner > click hold drag the fill handle until all
the cells you want are filled
Use AVERAGE Function
Select the FORMULAS tab, click the AUTOSUM drop-down arrow, then click
AVERAGE. Press ENTER.
insert and move chart
click anywhere in chart ? under chart tools > design tab click move
Exit Excel
Alt + F4
Upper right corner click exit window
Click Microsoft office button, click exit Excel
upload and submit a file
excel interface ? upload from Excel in file, Enter name
exit file to upload
download and save
select file > save as > download a copy
workbook locate and launch
file > open > Press Cltr + 0 to quickly open Backstage view
excel insert new column
right click whole column to the right where you want to add column width ( column
height) type column width & select OK
add data to cells
on worksheet click a cell? enter your number needed > Enter tab
Bold text
click bold Ctrl+B
change font size
file > options > dialog box click general
increase width of columns
select a column or range of column > home tab > format column width & select OK
center and Italicize text
select text format > click bold Italic Underline button Home tab > Press Cltra + I
Use the sum function
select cell to the # you want to sum, click AutoSum on Home tab > Enter
use the fill handle
select cells ? small square bottom right corner > click hold drag the fill handle until all
the cells you want are filled
Use AVERAGE Function
Select the FORMULAS tab, click the AUTOSUM drop-down arrow, then click
AVERAGE. Press ENTER.
insert and move chart
click anywhere in chart ? under chart tools > design tab click move
Exit Excel
Alt + F4
Upper right corner click exit window
Click Microsoft office button, click exit Excel
upload and submit a file
excel interface ? upload from Excel in file, Enter name
exit file to upload
