Instructor Solutions Manual For Introduction to Marine Biology 4th Edition by George Karleskint

$ 16

CompTia A+ 220-1001 Core 1 Certification Practice Exam

$ 10

CompTIA A+® Certification Study Guide

$ 10.5

Education > QUESTIONS and ANSWERS > Excel Basics - Wall Street Prep (All)

Excel Basics - Wall Street Prep

Document Content and Description Below

Absolute Value - ANS-ABS(cell) access anything on the ribbon - ANS-atl auto size cell - ANS-alt h o i Auto sum - ANS-Alt = bold - ANS-ctrl b Borders (Outside Area) - ANS-Ctrl Shift 7 Ceiling - A ... NS-CEILING(cell, significance) round up to the nearest x, specified by significance Combinations - ANS-COMBIN(number, number chosen) - numbers of combinations given number and size of group (number chosen) Combing Sort & Subtotal - ANS-ALT A B - can add further clarity to data sets COUNT, COUNTA, COUNTIF - ANS-COUNT(value1, value2,...)counts the number of cells that contain numbers within the list of arguments. Cell w/ text are ignored. COUNTA same as COUNT except cell with numbers and text are disregarded. COUNTIF(range, criteria)counts the number of items in the range that satisfy a specific criteria - similar to SUMIF function. Create Drop Down Menu - ANS-ALT + D L Create new sheet - ANS-ctrl i w Date function - ANS-(year,month,day) but if you do DATE(Year(cell w/ date to reference)+1, Month(cell w/ date), D [Show More]

Last updated: 1 year ago

Preview 4 out of 13 pages

Buy Now

Instant download

We Accept: