FORMATTING DATA AND CONTENTS, Lecture notes of Information Technology

Download FORMATTING DATA AND CONTENTS and more Lecture notes Information Technology in PDF only on Docsity!

FORMATTING DATA

AND CONTENTS

CHAPTER#

MCQS  (^) cell editing mode shotcut (f2 or double click)  (^) Entering of DATE shotcut (ctrl+;)  (^) time shotcut (ctrl+shift+;)  (^) time and date through shotcut is not update  (^) using function for date and time is (=now() }  (^) function for date is (=today() }  (^) time and date through function is update  (^) by default time excel read as (am)  (^) by default writing font style is (calibri)  (^) wrap words or line break shotcut is (alt+enter)  (^) (ctrl-d and ctrl-R) are used to copy a cell either downward or to the right across a highlighted range.

 (^) when the curser is present, neither in row(1) nor column(1) then the sheet/page spilte into(4-panes)  (^) curser at A1(first cell of the sheet) then the sheet split into(4-panes)  (^) clicking of hide in the window group on the view tab, this will hide (current workbook)  (^) (ctrl+c) -> for copying the data  (^) (ctrl+v)->for past the data  (^) (Esc) -  for removing the copy lines around the data  (^) (ctrl+drag)the data-> for copy the data without using shotcut  (^) (only Drag)  for moving the data without using shotcut  (^) (ctrl+G)  shotcut for (goto)  in excel  (^) (F9)  for refresing the data (ctrl+alt+V)  shotcut for paste special.

 (^) by default format of number of excel (GENERAL)  (^) by default number of decimal is (2)  (^) (ctrl+shift+%)  percentage shotcut  (ctrl+1)  format cell  (^) sections of custom number format

1. positive
2. negative
3. xero
4. TEXT  (^) moving from one section to another section a symbol is used( ;)  semi colon  (^) “PKR “0.00” Recivable”; “PKR “(0.00)” payable”

• (^) postive numbr  written as (reacivable)
• (^) negative numbr  written as (payable)